Logical Operators¶
For logical operators, boolean expressions or expressions that evaluates to an INTEGER value are specified as operands; TRUE, FALSE or NULL is returned as a result. If the INTEGER value is used, 0 is evaluated to FALSE and the other values are evaluated to TRUE. If a boolean value is used, 1 is evaluated to TRUE and 0 is evaluated to FALSE.
The following table shows the logical operators.
Logical Operators
| Logical Operator | Description | Condition |
|---|---|---|
| AND, && | If all operands are TRUE, it returns TRUE. | a AND b |
| OR, || | If none of operands is NULL and one or more operands are TRUE, it returns TRUE. If pipes_as_concat is no that is a parameter related to SQL statements, a double pipe symbol can be used as OR operator. | a OR b |
| XOR | If none of operand is NULL and each of operand has a different value, it returns TRUE. | a XOR b |
| NOT, ! | A unary operator. If a operand is FALSE , it returns TRUE. If it is TRUE , returns FALSE. | NOT a |
Truth Table of Logical Operators
| a | b | a AND b | a OR b | NOT a | a XOR b |
|---|---|---|---|---|---|
| TRUE | TRUE | TRUE | TRUE | FALSE | FALSE |
| TRUE | FALSE | FALSE | TRUE | FALSE | TRUE |
| TRUE | NULL | NULL | TRUE | FALSE | NULL |
| FALSE | TRUE | FALSE | TRUE | TRUE | TRUE |
| FALSE | FALSE | FALSE | FALSE | TRUE | FALSE |
| FALSE | NULL | FALSE | NULL | TRUE | NULL |